package com.vimi8.ebb.auth.service;


import com.vimi8.ebb.auth.model.GeoCodings;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by wangyang on 2016/9/8.
 */
@Mapper
public interface GeoCodingsService {

    /**
     *
     * @param geoCode
     * @return
     */
    @Select("select id,geo_name as geoName,region_lever as regionLever,prov,city,county,village,burg from geo_codings where id like #{geoCode} ")
    public List<GeoCodings> getGeoCodingsByCode(@Param("addressCode") String addressCode, @Param("geoCode") String geoCode);
    @Select("select id,geo_name as geoName,region_lever as regionLever,prov,city,county,village,burg from geo_codings where id=#{id}")
    public GeoCodings getGeoCodingsById(String id);
}
